DataViz Makeover 2

Explore different perspectives and approaches to design more truthful and enlightening data visualisation to reveal inter- and intra-zonal public bus flows at the planning sub-zone level of January 2022.

Frostbear https://sg.linkedin.com/in/farahfoo (SMU Masters in IT business (Fintech and Analytics))https://scis.smu.edu.sg/master-it-business
2022-03-27

1. Critique Task

Critic the data visualisation from its clarity, aesthetics and interactive design. At least three from each evaluation criterion.

bus trips

1.1 Clarity

1.2 Aesthetics

1.3 Interactive Design

2. Proposed Design

The initial sketch of the proposed design is as follow. The final chart may have slight differences as improvements are made when the visualisation is created in Tableau.

Sketch for revised visualisation

2.1 Clarity

2.2 Aesthetics

2.3 Interactive Design

3. Visualisation on Tableau

Pls view the revised visualisation on Tableau Public here

Revised visualisation in Tableau

4. Step-By-Step Preparation

4.1 Load the .csv file “origin_destination_bus__SZ_202201” and the “MP14_SUBZONE_WEB_PL.shp” xls file into Tableau as data source. Link the 2 files by the key fields Destination Sz with SUBZONEM, and Origin Sz with SUBZONEN.

4.2 Open a new tab/chart and drag the field “Geometry (Mp14 Subzone …)” from the Destination Map source to form the base map chart.

4.3 Next to put in colour scaling to represent the number of trips, * select the field “Total Trips” from the Origin destination file to the Colour feature. * select the field ” Origin Sz” from the origin destination file to the Detail feature of tableau.

By default, the higher the number of trips in the darker the colour.

4.4 Add in the “Destination Region” and ” Destination” fields from the origin destination file to the filter box to enable users to select the town they are interested in. Ensure the selection is boxes, to enable multi-select of the region and towns.

Edit the title as below to ensure the chart is clear to the reader that it is showing where the visitors are from to the Destination planning area. Bond the font and change it to blue to make it obvious to readers in the title.

4.5 Open a new tab for the visualisation of number of trips by origin and input the fields as below in the picture. * Adjust the size of the circle to the middle size. * Ensure the title has a clear description and mentions the selection destination

4.6 Open a new tab for the visualisation of the hours data. This visualisation will show at which time of the day there are more bus trips. * select the shown fields into the row, column, filter and detail.

* Check that it is working with different selections. eg. when selecting Paya Lebar, you should be able to see that the bubble to Tampines East at 7am has a big red box, indicating that the number of bus trips from there is more than others.

4.7 Open a Dashboard page and pull the 3 charts created: map chart, the number of trips chart peak hour chart, into a dashboard page.

4.7 The Origin Analysis Dashboard link will bring users to another visualisation for the user to explore the data, bit from the origination of the bus trip perspective, studying where are people from eg. Ang Mo Kio going to.